# encoding=utf-8
from __future__ import print_function

import pandas as pd
import numpy as np

datafile = '../dataSets/chapter4/data/electricity_data.xls'
outfile = '../tmp/eletricity_data.xls'

data = pd.read_excel(datafile)
# print(data)
data[u'线损率'] = (data[u'供入电量']-data[u'供出电量'])/data[u'供入电量']

data.to_excel(outfile, index=False)
